package com.yihuier.yihuier.Mapper.Common;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.Date;

@Mapper
public interface ServiceCheckMapper {


    @Select("SELECT company_deadline FROM bz_company WHERE company_id = " +
            "   (SELECT department_belongs_company FROM bz_department WHERE department_id = " +
            "       (SELECT department_id FROM bz_department_user WHERE user_id = #{user_id}" +
            "   )" +
            ");")
    Date checkUsersCompanyService(@Param("user_id") int user_id);


}
